select count(*) from User u where u.username='roy'